Notes/Domino 6 and 7 Forum : Database Properties Stored in Icon Design Element

Sometime ago I found, and then lost an extremely useful document in the R5 Forum which detailed the database properties stored in the Icon Design Element.

I've been looking again and still not finding it thought I'd compile my own and post it here for anyone who is interested, and my thanks to the unknown author of the R5 document that helped before and prompted me now.

Here goes:-

Many database properties are stored within the Icon Design Element in the $Flags field. This means that these are accessible and can be updated using LotusScript.

The list below is a list of the flags I have found values to, please note that the flags are case sensitive.

Flag = Meaning / Action
4 = Allow Soft Deletes
Z = Enable LZ1 Compression
f = Do Not Allow Stored Forms
z = Do Not Maintain Unread Marks
h = Mark Parent Document on Reply or Forward
J = Use JavaScript when generating Web Pages
F = Launch Designated Frameset
n = Never Show Policy (ie. Never show About Database when first opened)
7 = Large UNK Table (ie. allow more fields in database)
6 = Allow Design Locking
K = Restore as lasted viewed by user
c = Show About Database if Modified
Q = Replicate Unread Marks to Clustered Servers Only
U = Replicate Unread Marks to All Servers (appears with Q set)
2 = Optimise Document Table Bitmap
3 = Maintain LastAccessed Property
1 = Don't Support Specialised Response Hierarchy
M = Multilingual Database
X = Web Access Requires SSL Connection
8 = Web Access Don't Allow URL Open
i = Display Images After Loading
5 = Allow Document Locking
g = Database Type = Library
j = Database Type = Personal Journal
b = Database Type = Domino Directory
B = Database Type = Directory Catalog
m = Database Type = Multi DB Search
u = Database Type = Portfolio
A = Database Type = Mailbox
r = Database Type = Mailfile
p = Always Show About Database Document (ie. When Opened in the Client Property)
l = Launch Designated Navigator
s = Launch Designated Navigator in Own Window (used in conjuction with l above)
a = Launch First Attachment in About Database Document
d = Launch First DocLink in About Database Document
P = Web Launch = Show About Database Document
S = Web Launch = Open Designated Frameset
E = Web Launch = Open Designated Page
L = Web Launch = Open Designated Navigator in its Own Window
D = Web Launch = Open First DocLink in About Database Document
T = Web Launch = Open Designated DocLink
V = Web Launch = Open First Document in Designated View

Where the flag launches a specific design element, eg, Web Launch Designated Page, the value of the page is stored in another $ field, eg. $DefaultWebLaunchPage
Other values, eg Soft Delete Period etc are also stored in the Icon Design Element

The $Flags can be set using the following code snippet

Set doc = db.GetDocumentByID("FFFF0010") 'This is the Icon Design Element
doc.~$Flags = doc.~$Flags(0) & "x" 'Where x is the flag value you want to set
doc.Save (True, False)